package com.qianyu.project.mapper.provider.smj;

import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.SelectProvider;
import org.springframework.stereotype.Repository;

import java.util.List;
import java.util.Map;

@Repository
public interface smjProviderDao {

    //获取班组类型
    @Select("select * from provider_type")
    List<Map<String, Object>> list();

    //获取班组信息
    @SelectProvider(type=smjProviderProvider.class,method = "providerList")
    IPage<Map<String, Object>> providerList(IPage<Map<String, Object>> page, Map<String, String> params);

    //获取部门名称
    @Select("select * from dept")
    List<Map<String, Object>> getDept();

    //获取员工信息
    @SelectProvider(type=smjProviderProvider.class,method = "getEmp")
    IPage<Map<String, Object>> getEmp(IPage<Map<String, Object>> page, Map<String, String> params);

    //获取合同信息
    @SelectProvider(type=smjProviderProvider.class,method = "getLaber")
    IPage<Map<String, Object>> getLaber(IPage<Map<String, Object>> page, Map<String, String> params);

    //获取合同附件
    @Select("select * from attachemen_info where id in (${id})")
    List<Map<String, Object>> attachemeninfo(String id);

    //获取银行信息
    @SelectProvider(type=smjProviderProvider.class,method = "getBank")
    IPage<Map<String, Object>> getBank(IPage<Map<String, Object>> page, Map<String, String> params);
}
